Query Functions
Functions
- Pivot - this is a mechanism to rotate selections between drop zones in your query design
- Show and Hide Empties - this is a mechanism to hide or show empty empty cells in a result set
- Totals - this is a mechanism to add various types of totaling to your (grid) report
- Sorts - this is a mechanism to add value sorting to the query
- Filters - this is a mechanism to add numeric data filters to the query
- Eliminations - this is a mechanism to manage elements and combinations of elements that have been removed from the query
- N-of-N - this is a mechanism to provide iterative 'loop in a loop' logic to the query
Other Related Functions
The following wizards -found on the Query tab - are heavily used with building functional changes to a query. (They technically create calculations in the application).
- Variable Lists - this is a wizard to build switchable selections into a query
- Time Calculations - this is a wizard to add specialized time based calculations to your date-time hierarchies for time based analysis